<?php
/*
	Copyright 2006, 2007, 2008, 2009, 2010 Bastiaan Grutters
    
    This file is part of Ages of Strife website.

    Ages of Strife website is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    Ages of Strife website is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with Ages of Strife website.  If not, see <http://www.gnu.org/licenses/>.
 */
include( "../global/initialize.php");

$query = "SELECT count(*) FROM village WHERE ruler_id = " . $_SESSION[ 'ruler_id' ];
$result = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$max_officers = $row[ 'count(*)' ] * 2;
$query = "SELECT count(*) FROM officers WHERE ruler_id = " . $_SESSION['ruler_id'];
$result = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$total = $row[ 'count(*)' ]; 
$name = formatInput( $_POST[ 'officer_name' ] );

$query = "SELECT count(*) FROM officers WHERE name = '" . $name . "'";
$result = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$exists = $row[ 'count(*)' ];
if( $total >= $max_officers ) {
	$_SESSION[ 'train_officer_status' ] = "You can't train any more officers! (Maximum is 1 officer per village)";
	header( "Location: armies.php" );
}
else if( $_POST[ 'officer_name' ] == "" ) {
	$_SESSION[ 'train_officer_status' ] = "You must enter a name for an officer.";
	header( "Location: armies.php" );
}
else if( $exists > 0 ) {
	$_SESSION[ 'train_officer_status' ] = "An officer with that name already exists.";
	$_SESSION[ 'recruit_officer_name' ] = $name;
	header( "Location: armies.php" );
}
else {
	$query = "SELECT count(*) FROM officers WHERE name = '" . $name . "'";
	$result = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
	$row = mysql_fetch_array($result, MYSQL_ASSOC);
	if( $row[ 'count(*)' ] == 1 ) {
		$_SESSION[ 'train_officer_status' ] = "An officer with that name already exists!";
		header( "Location: armies.php" );
	}
	else {
		$query = "INSERT INTO officers ( name, ruler_id ) VALUES ( '$name', " . $_SESSION[ 'ruler_id' ] . " )";
		$result = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
		header( "Location: officer.php?name=" . $name );
	}
}
?>
